SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create PROCEDURE [dbo].[usp_ShowRecruitParticipants_applySchool]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	/* SET NOCOUNT ON */
	SELECT dbo.JOL_Recruitment_Participants_apply.id FROM dbo.JOL_Recruitment_Participants_apply,dbo.JOL_Recruitment WHERE  recruitment=dbo.JOL_Recruitment.id AND type='校内专场'
	
	RETURN
GO
